SQL - Query to get server's IP address

Question

AVADHESH PATEL · Answer

Hi Jeet!You can get server name as belowSELECT @@SERVERNAME;IP Addresss or Name as belowSELECT SERVERNAME = CONVERT(NVARCHAR(128),SERVERPROPERTY('SERVERNAME')) and ,LOCAL_NET_ADDRESS AS 'IPAddressOfSQLServer'and ,CLIENT_NET_ADDRESS AS 'ClientIPAddress'and --, NETBIOS = CONVERT(NVARCHAR(128),SERVERPROPERTY('COMPUTERNAMEPHYSICALNETBIOS')) and --, [MAXDOP] = (SELECT VALUE_IN_USE FROM SYS.CONFIGURATIONS WHERE NAME='MAX DEGREE OF PARALLELISM') and and --, SQLMEMORY = (SELECT VALUE_IN_USE FROM SYS.CONFIGURATIONS WHERE NAME='MAX SERVER MEMORY (MB)') and --, EDITION = CONVERT(NVARCHAR(128),SERVERPROPERTY('EDITION')) and ---, COLLATION = CONVERT(NVARCHAR(128),SERVERPROPERTY('COLLATION')) and --, ISCLUSTERED = CONVERT(BIT,SERVERPROPERTY('ISCLUSTERED')) and --, ISFULLTEXTINSTALLED = CONVERT(BIT,SERVERPROPERTY('ISFULLTEXTINSTALLED')) and --, ISINTEGRATEDSECURITYONLY = CONVERT(BIT,SERVERPROPERTY('ISINTEGRATEDSECURITYONLY')) and --, FILESTREAMCONFIGUREDLEVEL = CONVERT(TINYINT,SERVERPROPERTY('FILESTREAMCONFIGUREDLEVEL')) and --, FILESTREAMEFFECTIVELEVEL = CONVERT(TINYINT,SERVERPROPERTY('FILESTREAMEFFECTIVELEVEL')) and --, PRODUCTVERSION = CONVERT(NVARCHAR(128),SERVERPROPERTY('PRODUCTVERSION')) and --, SQLCHARSETNAME = CONVERT(NVARCHAR(128),SERVERPROPERTY('SQLCHARSETNAME')) and --, SQLSORTORDERNAME = CONVERT(NVARCHAR(128),SERVERPROPERTY('SQLSORTORDERNAME'))and and FROM SYS.DM_EXEC_CONNECTIONS WHERE SESSION_ID = @@SPID

forum

SQL - Query to get server's IP address

Anonymous User

Can you answer this question?

1 Answers

Liked By